This model dimension represents work order information and is based on the IFS Cloud dimension DIM_WORK_TASK.
Attribute | Description (where applicable) |
Order No | Work Task Seq |
Site Code | Code of Site |
Work Order No | Work Order Number |
Work Task - Order No | Work Task Number - Sequence |
Work Task No | Key. Work Task Number |
Model Name |
Maintenance |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
WORK TASK | DIM_WORK_TASK_TM | DIM_WORK_TASK_BI | DIM_WORK_TASK | On Line |